let server = require("express")();
let mysql = require("mysql");

server.all("*",function(req,res,next){
    //设置允许跨域的域名，*代表允许任意域名跨域
    res.header("Access-Control-Allow-Origin","*");
    //允许的header类型
    res.header("Access-Control-Allow-Headers","content-type");
    //跨域允许的请求方式 
    res.header("Access-Control-Allow-Methods","DELETE,PUT,POST,GET,OPTIONS");
    if (req.method.toLowerCase() == 'options')
        res.send(200);  //让options尝试请求快速结束
    else
        next();
})

let sql = mysql.createConnection({
	host       : 'localhost',
	user       : 'root',
	port       : '3307',
	password   : '123456',
	database   : 'mybatis'
});

sql.connect();
server.get("/flightItem",function(request,response){
	sql.query('select * from demo',function(error,data){
		if(error){
			console.log(error);
			response.end("error");
			return;
		}
		response.end(JSON.stringify(data));
	})
})

let demoId = 0;
server.get("/demoItem",function(request,response){
	demoId = request.query.id;
	server.get("/demo_con",function(request,response){
		sql.query(`select * from demo where id=${demoId}`,function(error,data){
			if(error){
				console.log(error);
				response.end("error");
				return;
			}
			response.end(JSON.stringify(data));
		})
	})
	console.log(demoId);
})



server.get("/solveItem",function(request,response){
	sql.query('select * from solve',function(error,data){
		if(error){
			console.log(error);
			response.end("error");
			return;
		}
		response.end(JSON.stringify(data));
	})
})

let solveId = 0;
server.get("/content",function(request,response){
	solveId = request.query.id;
	server.get("/content_con",function(request,response){
		sql.query(`select * from solve where id=${solveId}`,function(error,data){
			if(error){
				console.log(error);
				response.end("error");
				return;
			}
			response.end(JSON.stringify(data));
		})
	})
	console.log(solveId);
})

server.listen(81);
console.log(`server is runing at 81`);